from django.shortcuts import render

# Create your views here.
from django.http import HttpResponse
from website.models import Majors, Colleges, Provinces

allYears = set()
allMinScores = set()
allColleges = set()
allProvinces = set()
allMajors = Majors.objects.all()[:5000]
i=0
for m in allMajors:
    m.collegeID_id = Colleges.objects.get(collegeID=m.collegeID_id).collegeName
    m.provinceID_id = Provinces.objects.get(provinceID=m.provinceID_id).provinceName
    m.save()
    i+=1
    print(i)